SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 611069 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 611069 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533556,103487,215250,100389,453378,942311,18321,333943,442938,331539,864001,953112,646097,198089,890084,172644,968427,112461,589392,97160,681978,310010,375774,56550,205850,46626,623399,909928,207921,264914,108938,894896,215202,485602,298012,1032742,932318,1029983,15578,686169,459359,438890,332193,361222,357789,744603,599792,205157,324469,312017,1014751,309143,1030349,874796,118990,1033380,971861,32183,717257,729678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 611069 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 611069 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]