SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200331 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200331 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151042,130589,488409,468299,1019224,228471,674650,267050,972154,999806,463271,927214,505085,541632,111645,364924,1045759,293270,1041405,77623,515853,1044698,428987,6510,2402,908281,825690,424809,1043451,172171,932951,22155,58130,589226,50560,604489,950966,922595,636511,729310,1047474,765144,347250,671979,918414,939873,290841,893799,1024902,996301,79833,197730,582540,856727,789792,234510,675051,17921,334018,903998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]