SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042161 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042161 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449359,147024,63546,346835,186458,704117,553179,811812,250189,908385,294591,479272,542337,829963,231589,787675,608788,858603,13171,1048766,293548,623279,734239,260414,847887,287337,876341,905831,258218,948543,204008,562984,724430,509095,551035,587463,608194,538199,1031061,969688,506000,655768,165979,797920,589095,116897,957278,857449,713607,328073,819935,253614,655150,691641,905522,892190,448853,807618,291002,854502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]