SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507319 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507319 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564842,844240,414076,632394,838332,619100,462470,879709,321013,235428,476015,302387,947144,293296,547073,629500,61657,297861,935981,234370,398479,73129,646372,284275,637707,243106,495651,378155,633879,123246,269392,101116,854345,350917,570471,80498,27701,468252,20959,340041,605000,738069,1028823,632664,243384,151796,981159,966215,967092,266436,270812,164621,33380,727039,120245,150510,410880,458147,430333,92246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]