SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 124160 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 124160 [ RunTime:0.002666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653202,1037836,1022564,486407,809647,466910,978977,526245,379859,186735,719282,488689,804512,138966,749364,500633,769464,32747,958469,250848,454673,133835,1008476,52085,142317,523034,123356,363682,377668,703754,516092,374682,954496,72129,350593,1031276,930590,555951,757486,212530,167421,44597,161400,459737,570735,1011598,111662,152934,833962,200988,972557,421087,386718,738049,29564,964300,723857,803911,251655,127731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 124160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 124160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001693s ]