SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291380 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291380 [ RunTime:0.001466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326665,34620,719620,815772,716034,522360,913691,513315,763364,811072,991719,366401,579276,111765,948278,13194,197309,600530,889890,376915,677584,105015,449664,812917,174134,492162,213152,257387,406824,554795,1006364,1008467,48843,567545,116483,11608,199889,476027,764411,460623,610503,650982,583943,1002135,518301,745612,170485,185211,199171,916458,898332,11402,836221,687165,455984,198037,218671,570710,1009387,262984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]