SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550427 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550427 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559687,967865,710354,340779,781983,736449,527768,182589,146187,564760,868105,700391,43726,415381,662248,523621,369601,480575,608947,270271,267180,692561,497566,94086,921390,105892,299924,120800,803765,47486,506056,737514,577418,964586,900416,710587,772253,987593,864743,561215,503424,220101,117381,107229,304592,727725,432715,178166,283029,102556,545410,125374,685307,961202,302306,45470,126402,369294,74877,450745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000921s ]