SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039122 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039122 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559239,867083,615328,424339,691100,128005,299730,378190,49201,444305,388686,880092,48674,844908,573122,252415,356961,511313,1009897,457983,137125,885904,220013,112646,947995,594895,984070,47909,562686,127222,581034,496787,800142,151889,416922,978350,907489,455043,890640,954324,316853,292182,624226,105393,291205,890487,323198,380123,460789,808362,118600,663157,440737,750203,547287,701226,478518,816125,305416,666848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]