SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531039 LIMIT 1 [ RunTime:0.001295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531039 [ RunTime:0.002932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807561,264478,492821,899012,871538,581841,904578,854708,317660,245658,878765,468927,610902,559223,615963,819034,189576,963152,723357,996552,331527,1040105,355425,557793,528036,379711,740060,1048473,79857,867529,221737,802232,10654,679053,229440,236074,47953,585899,85159,845345,419592,715122,328880,240959,343206,89891,777048,338424,295460,876257,875394,1040194,904174,754901,872899,681093,516040,398338,900174,746935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.052925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002150s ]