SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401972 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401972 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216072,783156,863782,426891,693490,384406,439255,273245,304582,1024206,331689,702691,641010,489295,867164,491664,994747,737443,1011049,655981,749866,762753,432071,633060,997559,680633,834821,1006099,761627,948317,721679,744060,523564,197922,519870,50279,351174,368834,845459,628524,121916,525102,107047,1030581,709890,15807,815647,112809,343478,867959,98941,117969,841184,794512,144374,675843,40239,283328,181030,992259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]