SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585401 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585401 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281376,660514,513778,448142,1000988,647857,824189,557904,35076,460771,860515,585759,529200,876420,357920,160505,644115,1048801,40883,368007,505734,939139,285034,996953,1006501,341923,527525,240485,276782,365325,547393,123870,369950,991365,266702,460803,361871,716302,111312,275523,621036,393911,801535,762043,615015,500095,520156,835025,175785,741997,56168,891069,795074,964220,979496,129638,199985,1001889,122502,255503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]