SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34604 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34604 [ RunTime:0.002192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656953,1016705,923504,257973,82583,70663,467901,181403,271124,865597,562491,710142,689613,20360,517034,519612,501295,2053,694262,461508,533934,313604,718339,243159,842199,533991,7722,570960,733698,345380,449164,524754,577295,231038,147123,686666,992116,876506,799812,945923,935369,999474,808230,52899,635637,918722,992306,582319,898879,775349,799882,568626,587602,459301,819457,900664,37525,408116,57201,92457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002126s ]