SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002783s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985041 LIMIT 1 [ RunTime:0.005250s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985041 [ RunTime:0.005440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731898,303131,221263,112213,649913,897237,4933,724119,448741,484628,488980,357348,65380,681244,987339,821771,72578,253779,208164,127204,185054,159469,796472,635773,881952,69046,767918,599304,471391,1035647,332267,388503,17313,675119,730055,125868,947206,276284,562642,791635,806787,301885,27932,891200,507556,62926,571192,130768,352448,37236,856940,215046,43220,575965,373605,614203,987495,303863,702610,808887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]