SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597091 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597091 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203061,289533,646427,640657,46069,451617,180628,612885,340742,239645,121326,980573,703410,274487,483942,792904,399968,285943,805047,776857,206621,296324,470950,954695,857529,628576,94476,182448,1019513,357437,956528,292393,813427,367431,453935,683843,493512,941434,909349,140713,347274,588381,818215,829386,353489,753616,648997,517398,588756,31136,787535,613091,330188,613325,513873,998688,325040,797020,59654,16215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]