SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429770 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429770 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304495,390684,1012279,783833,227042,689155,159248,950442,731695,626332,105824,540261,563693,526799,976049,28088,80398,1035899,856709,67058,920080,1028902,490733,83091,611836,625140,62369,950779,261086,527329,495461,171993,577867,931325,17187,355482,801055,171835,59654,422762,135071,416861,92575,466086,822114,796897,75774,586314,869488,1044108,1001710,622159,777656,22522,565354,115895,4471,336936,928365,908593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]