SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579099 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579099 [ RunTime:0.003026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269134,959601,382464,4463,567594,442265,1039087,280957,880061,881162,414945,278553,842151,542205,641843,541810,185564,142285,896954,969384,649061,416517,256573,541737,615370,451697,588741,752408,786520,131413,767353,833486,281182,883884,184709,156964,551657,667596,1045362,344734,385579,290497,896369,772942,529997,43943,360452,167843,841782,564300,204914,676656,755467,494769,770235,640564,739622,732309,57533,728688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]