SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528409 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528409 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764910,924791,877165,806258,806607,514935,482329,299443,185648,496059,101803,244875,18112,626089,980278,762045,202112,984112,18350,297419,26341,811715,137135,972932,129386,24800,106082,330227,576836,357129,731069,275232,504232,223825,484342,505217,788776,878539,833482,999010,487590,1018758,767798,315109,1031296,394395,437826,612790,1032091,874814,342725,515209,822482,652554,849839,391255,961445,598904,337722,215629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]