SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497748 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497748 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437013,950033,101817,783018,101880,662540,668765,372280,528387,474559,678341,77885,672074,651170,714236,297846,1017779,990361,1008490,9127,698157,292386,907958,559003,737580,737682,439638,815131,575944,1004610,845166,254734,460228,822706,279776,382404,265564,408255,905691,673792,900727,197266,983621,955894,197370,210754,879928,762978,420073,975105,547373,890750,392151,504434,1003530,140779,168485,997806,70778,266542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]