SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52811 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52811 [ RunTime:0.003186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472300,236817,716576,264259,147135,707408,353027,280466,153887,597474,514064,945552,428818,1020971,163621,951446,981444,451122,53694,553235,188404,39452,808388,933034,1000600,906676,314561,653427,936275,105206,13312,385083,44457,598528,30218,525438,1007651,380528,850927,192018,290473,562125,780262,272867,815343,656670,990951,782371,637396,834730,264632,794451,943982,794972,132196,858404,220631,321545,954515,146876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]