SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 95416 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 95416 [ RunTime:0.002454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301148,255012,408830,988404,99241,642902,299877,943558,920448,381855,359996,356558,733772,524845,22551,332485,978385,134648,173161,575150,90125,976159,184959,620572,428255,101451,201946,978911,611257,937069,948657,215681,816186,267805,562500,331882,631140,62158,686061,311020,837174,870277,267889,846299,667250,378733,322568,322691,375836,5068,1026928,994489,704297,21803,885646,498713,256005,1011822,402681,513088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 95416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 95416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]