SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402738 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402738 [ RunTime:0.002461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352149,906730,327329,243588,645117,183616,38469,1042491,822811,455329,416646,179439,174469,174600,325026,587935,478275,867022,147249,487812,364981,699992,784388,604538,689492,489147,10623,547200,273177,697885,757110,732058,214835,680911,284886,293453,228389,305174,833036,39395,1045938,653823,717481,667008,1030766,913946,716168,511465,855716,776111,844301,692209,380641,731139,399199,1024390,545474,742931,54141,604476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]