SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294823 LIMIT 1 [ RunTime:0.001393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294823 [ RunTime:0.002635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372898,668801,115821,532339,482200,245961,210105,121980,198694,763550,438696,926119,394715,673559,281146,729535,533350,853886,508718,618338,710409,938112,86029,481006,612128,626493,768720,551633,108905,776091,467373,254778,1001638,879412,186378,54539,434285,696599,363531,258714,372247,1032545,862718,915975,446367,256253,1046733,504397,686405,750806,551220,3455,244269,5351,157204,277617,956498,135014,473403,227880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]