SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103399 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103399 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036215,138629,328732,223307,641169,358765,348993,550862,323895,883849,286695,956858,785242,568312,150764,876962,907232,234438,849802,967597,37606,764948,522539,243482,866779,844765,648467,321413,619253,247903,122048,91267,593892,730379,940190,792514,610755,229634,501574,439971,606280,1018755,956216,605336,565503,657330,654448,635389,729617,123187,819021,202337,854260,1022139,427144,608514,653603,754881,398554,472806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]