SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002664s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107227 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107227 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484822,383306,539552,827168,394313,240063,841100,7959,622222,1014645,996134,596737,642581,188989,202019,271002,385912,716954,916788,860869,333848,224813,88166,554081,98638,520564,271617,797956,41057,334015,762726,895003,794513,831404,879475,136722,1004709,264852,577834,1022094,106644,382226,411401,363442,773374,400706,451204,175626,804484,498154,561630,864763,117138,166419,960508,185088,132740,266994,849462,981743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]