SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023708 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023708 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710806,555868,355137,292823,260821,670202,782875,479139,404334,912333,447300,712598,693457,401484,610871,280642,175880,63515,210771,483632,238266,314143,382197,418882,101076,848129,220573,956865,871295,457927,601590,828809,964299,394779,653694,734574,413656,506646,838667,716575,179483,267669,518106,3318,1000231,690708,658972,572854,76137,376741,690475,584071,400605,720224,83177,780122,776260,400704,634856,717224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]