SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404021 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404021 [ RunTime:0.002389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935386,453229,180823,92285,231077,981296,224486,522600,293243,710340,542506,40324,406047,186121,966034,531002,859766,236472,838587,1014060,130406,699208,505732,1010704,124462,474644,813748,585305,348193,546372,324660,409490,591097,577369,345445,541827,854122,310902,690703,1012097,465832,747222,306340,648184,363497,905959,629032,325054,443230,925839,446607,856154,429440,844225,1039349,653812,346050,107370,904701,332474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]