SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 789612 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 789612 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506791,117072,980168,931081,311697,187966,509378,82966,1030687,716722,609218,1021226,776972,182769,610836,731070,348037,234741,659983,501906,630547,288445,290596,495359,571734,277688,363368,573333,69811,650955,13580,121218,639474,620090,461981,470976,572,575108,884376,531305,107235,259350,963272,203142,127328,1008492,585840,447759,998127,905263,178333,181367,178072,970341,602660,951472,980688,503119,997217,885200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 789612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 789612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]