SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417318 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417318 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706579,579111,141118,777740,368298,219629,962033,821588,211039,791683,149015,288472,919673,762722,244088,746254,77291,258666,699403,984837,1036085,173888,273627,156707,914501,880202,782056,966629,26439,354799,137167,845382,1009965,405391,655920,1038318,345934,444223,890412,674496,649083,402104,18436,1041736,458224,229777,466714,351969,374170,761237,262780,907146,1014676,296179,9723,920475,409977,568899,65932,478874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002839s ]