SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807400 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807400 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811523,506925,795766,508086,892680,97973,114273,755655,625202,557902,373023,968347,756329,203337,544910,57035,1047893,829551,789572,1026751,326926,531715,211805,773133,943938,581947,249261,1048467,643174,590190,645077,952461,239076,982612,163743,357877,473549,625605,260613,845431,1047823,465250,666179,688390,501666,201519,1010325,393681,676434,506246,297818,500314,171751,425050,1022876,681217,107668,490199,560172,518659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001513s ]