SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586291 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586291 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816052,899310,443914,200874,839499,574511,449405,439042,405474,208695,581788,156474,835200,628412,948570,818501,775143,147939,512552,112815,316725,76406,120686,254415,895944,1024116,245103,879706,547644,624977,197087,276537,944138,105026,963102,231387,105488,101578,237374,1042702,95862,376528,579677,937537,283785,311523,1005558,673046,494890,415505,997523,744740,43503,362236,244152,1018293,47155,219204,26301,723820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]