SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 900080 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 900080 [ RunTime:0.002444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410864,214900,57603,123694,722781,970487,451265,505823,219606,448465,491724,473305,192464,703639,421592,828802,158064,557332,620056,586048,37239,720766,404878,743821,779010,3874,443961,111776,845248,320613,790457,636367,284255,363534,531444,514241,94762,317971,423904,553096,881353,700678,803360,472763,144158,403629,437783,971356,112452,943157,633247,648608,624928,582287,380627,772187,707528,511383,463852,604815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 900080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 900080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]