SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002990s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028647 LIMIT 1 [ RunTime:0.000809s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028647 [ RunTime:0.003356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003078,842515,132270,6688,135209,522823,904281,846534,1008274,18394,144440,22934,947123,108747,984135,381679,476749,870369,801678,864012,779283,182542,576993,883497,854601,99733,806585,474982,885852,875510,236388,1032373,413363,724263,525307,776330,375791,789059,695628,701348,148918,155240,96365,1043984,22243,875537,214243,972153,690434,639472,325951,599754,987782,900098,527319,30793,203807,490864,626405,224954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028647 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005882s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028647 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000927s ]