SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339443 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339443 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177366,389306,737821,185669,389164,548924,912033,334312,1045976,444742,410396,36884,292102,841067,857318,330932,277551,481482,426933,559069,258716,389738,674040,454900,236870,140121,240310,166351,664644,148019,1009105,483505,410937,68330,456297,710953,914756,595660,567855,71937,930921,322292,768091,907549,187230,762368,1048754,928435,1045835,799359,119231,261142,516860,194614,747016,735341,811411,652305,742956,415328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]