SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402327 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402327 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952845,669778,187089,337886,899627,73900,835334,740379,901555,991750,849718,944818,945816,567161,33639,627666,659789,202810,90420,758969,312097,667082,433268,442959,573657,985917,326433,523636,145440,128519,422966,1042618,889118,1010129,733270,295299,373953,662713,733014,481703,257902,270625,1025466,103692,489181,22564,769516,241251,856512,466039,156561,801882,426740,629333,494406,414161,1020466,595114,721988,313600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]