SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437806 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437806 [ RunTime:0.002603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528961,206012,302582,698125,129387,1031363,224653,988839,21936,803849,251263,839218,1004731,448274,556632,161509,767705,41477,429471,853178,109801,83260,948823,573555,870343,46623,730717,998494,281917,435438,756187,142211,519513,489092,603208,257428,838237,838334,804252,557260,622628,748627,723654,759631,593734,293193,397278,558294,31330,429679,517033,340095,783601,923773,292315,859134,880804,432265,195531,573961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003659s ]