SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512822 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512822 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287795,938419,897436,626756,883377,262055,916851,612312,468108,806594,827047,118626,614469,949875,431685,740276,273138,182162,1046692,513915,791493,748832,93198,231608,159614,757084,137635,780129,514556,874940,512941,549827,273744,520382,969774,13209,755943,10392,459366,193030,415865,277538,341378,171099,508800,222466,889326,752006,730423,22679,466858,809520,768907,413253,1017497,414783,823381,740808,588435,639585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]