SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391620 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391620 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048011,997150,727453,31460,954245,58169,112114,474529,893869,549431,190385,761395,65966,133666,256033,955574,785999,964669,861309,744347,515181,620658,893382,463038,162172,398328,475641,869720,411303,472193,363773,415717,983487,520264,187943,832161,126195,133716,92668,51109,21298,779869,712992,483047,371112,913072,470925,749739,695564,415346,566822,350060,1020002,980012,547414,453221,465855,322683,818028,188699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]