SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195084 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195084 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873603,490427,504186,634336,975017,152101,172797,36041,104001,651059,699904,343430,398577,503690,199065,49962,131198,883404,7567,493210,426544,553378,2991,718330,181617,293170,152392,411104,1044630,637878,577143,204314,659360,329920,516278,248617,160076,232525,804450,1018395,560855,670004,326098,603272,662381,793947,906082,105572,411640,629031,383433,389778,88636,161262,318220,897843,658005,1028253,233134,234830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000789s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000810s ]