SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419763 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419763 [ RunTime:0.005695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574840,5563,374624,902467,469870,886463,611503,101411,460083,951540,247854,926367,420485,926373,869333,427846,680654,830329,405359,588433,752231,758367,596484,766829,548747,1003530,622723,22806,634351,710690,59607,840090,372456,238181,84065,753968,276057,512048,679250,221118,366618,264414,148874,176021,108288,678053,51004,80088,243223,572533,1046834,665999,755840,981664,849387,927920,819379,842632,624827,132243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]