SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534004 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534004 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959216,517957,608303,352725,174063,67389,866249,531477,803598,960842,966299,229554,325973,233675,863440,331492,229750,934175,72762,1015971,469413,574735,767866,595100,244022,438081,263303,374965,603357,951253,388532,425457,693337,723884,451083,51265,145027,99241,190156,790503,751651,420894,548150,538201,1046482,558482,334302,826707,791687,634707,936820,650515,313952,1020278,118315,325197,724470,326423,831573,334209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]