SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33000 LIMIT 1 [ RunTime:0.000666s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33000 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476130,112058,1041821,204118,731023,23944,749250,227472,703790,700836,648036,1024780,286704,540887,1033169,598889,34057,1019833,1029633,560827,512709,412183,1001671,331459,308712,930183,1023163,496628,550425,959980,236234,727967,535470,207297,336063,43335,638955,927690,972689,115971,347859,250951,188383,387960,111601,170198,833322,895379,817785,712619,34403,25727,738953,157014,574429,35356,483474,370599,999090,556796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]