SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406834 LIMIT 1 [ RunTime:0.001439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406834 [ RunTime:0.002573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152874,8508,230010,265786,304494,715024,149055,514720,463190,581991,458271,130115,699436,456047,297408,963086,953115,272642,743798,876366,850039,1041639,525558,792618,434267,360946,226153,752284,340814,142396,668570,417691,357909,683032,80807,795639,572786,891460,807364,349625,517615,1034930,348475,325755,812476,258340,1013901,581082,237336,817896,375594,560884,829753,315202,947645,110859,286562,244158,803929,271954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]