SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512954 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512954 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911400,525530,825343,732024,129071,671283,645932,788347,476113,464724,471637,192223,1031520,50434,376661,703037,904924,99438,509643,987692,609252,986493,447982,180460,110489,620476,804003,262513,15816,624044,787259,911911,996291,686456,743021,655001,948497,759087,738331,887731,488935,356579,513794,207719,239318,1013960,310384,308373,917669,866743,910610,426139,211090,847305,148202,943607,714238,656751,591832,668017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]