SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 862841 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 862841 [ RunTime:0.002253s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110571,326142,34607,30107,722740,488215,347887,659812,270274,332897,267353,670816,117662,681078,168704,443861,890001,460457,834044,583959,113458,681593,38633,1019060,105110,101550,864908,1007217,507222,1011748,765844,1013866,464948,3855,447459,536770,940610,277132,287870,960906,624663,110193,615930,894602,366084,270812,270186,947383,758098,307438,985288,542916,469968,241027,116439,332395,874160,476673,60034,391511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 862841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 862841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]