SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514482 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514482 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104829,902068,575131,852325,755612,491430,145354,572296,1006782,245447,835715,623500,677661,25603,143976,1048519,764848,79107,812975,630573,94795,559753,845548,828749,268008,631446,465849,436524,328843,1020219,575945,329529,649638,803212,403114,357498,802359,73135,821063,435538,513481,412938,602536,1031915,363742,976245,176261,756880,599055,264989,618889,179190,759624,483954,822796,867401,68566,730002,732774,175109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]