SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330519 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330519 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275807,960392,866338,423656,1002970,1026439,78444,530197,727017,704671,1048578,106767,580638,178691,107514,409903,395190,736835,968959,1042587,890713,688267,426568,945351,116969,546206,715867,913338,673581,137731,855890,733821,641097,979113,472551,59730,815871,606264,38448,20423,288739,391839,577649,233699,640784,783585,292791,907027,246100,743090,135528,959750,785150,743437,673440,687326,268592,883577,59964,545821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]