SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311693 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311693 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297730,436347,653907,52087,788085,264763,774009,148749,820311,528417,767422,877188,402020,443962,462668,383188,836442,909608,638377,982804,145700,1033250,190112,534130,809296,1010452,273132,487252,508399,165228,46998,886272,862842,519839,415317,209681,13692,1010868,28012,16518,190240,162833,486907,319262,234437,490341,920818,330738,36418,898366,43960,833711,995510,799838,91985,1023446,958141,217456,991755,982344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001583s ]