SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509529 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509529 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815998,269880,673533,125240,10894,327223,989879,561038,131032,501523,567536,705218,905660,961231,74152,2111,125527,100532,562538,877067,722946,755423,211965,828176,208300,834538,923671,733260,941837,248169,1007267,140593,490361,389257,1032897,63281,230535,488907,1029844,377335,108657,435641,877066,691144,374063,642103,505805,227539,593718,719937,1939,67408,312595,165597,669826,682933,562373,56635,249315,830157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]