SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303340 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303340 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474480,1023766,768515,151249,670177,588494,1041495,675919,340010,802091,976115,858033,691933,52004,451024,145153,858860,809912,747697,216312,165964,208847,64235,551878,1017373,915852,899665,701758,335713,551524,752109,94370,593169,360270,576089,344354,946458,872787,270891,153802,833252,502294,336846,63823,120649,1040541,411969,649203,759482,384366,125165,62640,535961,907879,773535,579249,1018093,184051,280898,1020384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]