SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451699 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451699 [ RunTime:0.002424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347116,403703,53859,318092,456080,928553,1010883,158096,493419,59383,1033194,87755,949934,1039385,410431,800028,661629,421029,562899,814896,726601,630895,393467,408901,266520,231633,828510,289044,482464,173430,1048222,757389,646999,697460,1045233,712535,762623,930745,714027,716031,632821,429817,764888,568179,280539,607417,57914,921531,733509,231251,966714,185886,689383,601065,68968,265788,581478,805816,369481,32669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]