SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354991 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354991 [ RunTime:0.003407s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864588,566675,332918,688185,21495,19558,30111,584956,992322,90094,9080,641100,108870,556136,213290,222666,887449,593906,479543,372561,439091,408818,26795,707694,960295,120654,18755,27584,1882,607905,485384,450893,15688,590440,844729,2654,512516,139737,2765,974588,82160,798278,254627,373005,579230,488464,665826,729216,177892,12651,561750,360183,942217,243500,601484,80166,143077,531429,39410,556646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]