SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504605 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504605 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046216,617544,490296,270015,349553,603946,321007,360113,838131,16281,993884,1035100,933146,262211,121781,479068,969067,143918,338999,751231,447021,370458,427224,443493,140932,515816,998096,992835,517174,451094,376782,142291,446535,1020333,950266,419982,450383,2551,345310,673375,812366,82725,263252,933413,226445,450402,237735,508156,836587,148813,215617,134059,405968,919695,682140,975952,629953,665011,434988,518301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]