SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545445 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545445 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646076,274750,529180,256101,945325,542204,320131,225629,706335,226301,763605,976711,630044,422155,190406,242429,798559,126177,828348,386178,763470,133964,968908,864174,761356,529319,761398,261393,1024722,1017411,170053,930285,894652,536783,102719,674079,991313,33922,469707,733269,183885,716675,972639,43725,567220,197329,154786,266913,212312,160285,1047273,1028295,337809,730889,886966,126540,857857,484796,62689,360472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]