SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286811 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286811 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729875,627038,854817,375097,305707,396159,152165,150395,850528,182050,447577,912087,963042,93143,245106,805579,515181,359180,227047,729348,60883,658906,300695,1037823,903460,153051,76936,399919,923817,976229,454567,369340,585582,189416,303056,885618,806690,1002501,246705,180423,434469,734692,24294,334792,766494,1017535,104852,179539,871960,315472,538983,304195,256146,688723,775840,685847,6091,665967,375309,817064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002323s ]