SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103511 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103511 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126639,279468,281101,906646,672742,615546,354865,372806,464575,775470,199785,400179,749543,932643,238527,999543,148249,842691,38301,634754,840438,244468,916065,471562,173470,769277,145586,570786,61042,451533,998922,313062,1010976,203351,894832,155551,548288,487616,89543,959725,68984,997715,838182,125530,473927,960941,696902,1025836,579105,751386,18051,20305,763541,412404,355475,612101,431172,26299,677684,438208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]