SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 247514 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 247514 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034481,25735,1041866,1001620,867300,265520,681414,235774,456502,989143,179061,526743,314411,957739,217822,123383,806062,477219,680856,459558,89569,975633,748165,578278,215342,464786,679427,585071,201211,211353,72101,324979,599013,962177,55613,482250,486763,485398,803716,205027,615817,930073,30237,566028,251242,911892,183969,1011622,800465,217647,799209,27076,838830,317526,848046,479986,437507,390019,246718,248895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 247514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 247514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]