SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428089 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428089 [ RunTime:0.003068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341071,449300,390580,233926,103332,568809,225613,324088,723437,639708,347235,437838,498767,542986,911725,266246,1044075,674700,510094,309267,292343,1013988,570008,710606,58165,367386,40384,917893,721730,379165,1025445,859822,9256,259304,1020394,510823,637639,846872,222357,848821,863835,521160,851199,903253,306245,155124,841611,366126,125150,256054,330481,692724,292341,494242,509471,799594,823416,654339,1007460,964633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]