SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 216151 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 216151 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49700,192786,371344,49046,245838,760487,535871,754823,923597,640413,71270,255886,623744,434273,478973,415884,387264,128559,932180,807893,707020,572425,464556,1035997,1026587,1035676,529866,843975,127195,148260,94187,207580,78506,1033919,997045,577028,594628,331297,510806,583689,1047756,48954,970343,622221,756028,544121,174231,935242,60299,902506,416315,606587,456404,42601,343540,647778,850619,316807,566274,398354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 216151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 216151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]