SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 726813 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 726813 [ RunTime:0.003888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741759,539470,964909,513007,305916,728435,532329,911396,377573,868224,392565,689379,754538,334631,787775,639448,786264,106050,835247,801615,381930,957071,704525,537235,56417,679898,781373,100080,115367,984927,299579,39481,658152,680348,341826,771300,582277,533594,404063,470307,129351,795257,597992,878044,1018489,774572,914107,346201,22533,181468,198685,567604,525549,474430,626657,751897,411148,137144,1022476,274779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 726813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 726813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]