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` = 540571 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540571 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59640,45776,706650,231962,486693,724096,481846,13660,929743,514429,631067,37010,467146,591084,1030280,906577,441215,882278,653185,262088,133875,406213,306873,698448,1002455,650564,848636,876859,639387,414368,499495,23156,131403,53752,234477,453152,275856,589744,302926,954360,537979,186008,172554,814455,908093,156941,92464,437327,482750,746600,156702,791928,779437,292988,596154,624259,567556,346489,865062,966002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]