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` = 1045544 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045544 [ RunTime:0.002351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549619,925252,957687,200542,684263,578375,164710,654959,402862,243785,137997,792444,765427,880093,543925,1012569,13246,107549,910988,184331,906635,964255,102056,40512,1047357,145838,975305,606046,120204,108333,773044,390531,497591,792612,63274,1019700,58956,231310,903539,939801,268398,557479,850042,1040958,1005687,819179,236740,689784,182819,249430,929697,899581,1042237,73014,171599,45181,363834,394732,815576,1021846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000737s ]