SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 67504 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 67504 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401233,602560,289805,260838,81745,588307,408077,468533,13817,252497,211122,409579,909387,46091,346855,104335,128894,826675,407771,33935,378251,965695,794744,693939,282878,304462,41064,501710,318325,458500,619919,935167,606516,652038,666624,784825,834779,800682,506682,943851,745595,122031,204889,105359,108574,582736,1025286,834825,443418,629726,627304,13455,1015511,984948,451224,426677,92112,975804,348253,949078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 67504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 67504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]