SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042438 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042438 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348620,558907,844412,594326,864591,546195,919997,280177,779509,354542,10202,555449,264543,874950,983282,190227,413875,438326,313382,1009159,372444,40644,6502,727451,364455,118772,16995,604457,817318,268086,357549,589906,396713,25916,1026058,96895,657366,81490,920399,550759,330755,101047,453365,798976,259628,677059,9401,833895,1029628,578522,511151,222314,142093,159261,513193,237905,340321,791396,968934,1020984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]