SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414612 LIMIT 1 [ RunTime:0.001084s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414612 [ RunTime:0.002588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394006,495860,712021,557902,268998,610757,329516,874646,345590,761397,575772,470283,124352,975388,330796,708227,612298,283860,479399,662088,114431,507391,663849,451197,689398,363146,6578,290843,1002565,965236,635757,440063,797524,725463,744052,796175,782709,623083,1045465,419191,963111,879792,923437,280854,703107,131303,446691,760868,844423,438080,819179,854840,673962,581025,639459,621618,135870,311382,512292,253267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001879s ]