SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336973 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336973 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021562,549859,304255,1045690,414916,348113,191795,789490,26006,742495,1002205,415015,839948,782749,521745,281664,112466,201423,882536,342460,695468,606582,527326,547766,490678,525459,637362,491981,65956,500391,929398,540645,663628,1011231,1020548,706337,532536,688099,727670,218672,85523,199074,164502,974853,225597,178275,312115,777100,760732,390591,544594,3434,379700,991327,1001572,694397,69050,134071,15250,341997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336973 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336973 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001428s ]