SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000083 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000083 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83665,341716,162698,963939,685660,570131,466907,173764,239851,1011178,860925,970229,406830,754901,889259,825224,51212,303796,890218,739967,323076,887961,644684,323185,362777,1015317,480147,15863,992177,569148,1030197,492795,814465,794908,777463,215548,433626,905633,419703,475511,32355,429567,288985,585738,400024,384273,989667,194311,997952,878268,1035948,9695,39040,801298,624819,245332,40134,737032,384935,490128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]