SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490014 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490014 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29131,902408,85179,1043016,836552,1001806,852714,424150,953657,245294,634671,141614,811395,415163,153993,631595,37694,554163,569854,574828,984736,860968,551556,241544,651680,515093,325416,394178,793456,430426,967,505591,770190,632856,415746,1002081,878542,285905,858442,544736,377230,139782,145391,187261,807828,560865,972521,413676,247926,907624,899354,766343,112736,163061,215911,117607,734040,82895,362671,16405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]