SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003857s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026736 LIMIT 1 [ RunTime:0.002433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026736 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573766,636737,381730,588780,499359,154620,502364,598005,749120,481383,1004386,791801,758704,383105,942157,605306,354533,950049,754276,133486,253626,427228,685212,819891,1047648,597975,166104,650732,866013,545673,101285,390874,595934,710985,119567,43846,551765,232383,1011122,1008086,500740,697407,466621,534398,667095,214176,986085,603326,124437,100987,961584,756213,579620,852713,56419,622549,753228,689792,944036,59686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026736 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026736 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]