SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508836 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508836 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402401,911702,237172,748012,929860,748559,288059,140382,62223,867985,54932,449160,567885,44677,195098,661675,575658,670287,638416,126293,129472,889072,86973,35762,778832,576165,78138,577947,237160,213176,1000560,723024,530947,717604,52410,134689,372290,1036091,300705,730566,715603,90822,683212,53584,630494,885103,381172,991470,589776,576726,581704,455360,919332,697344,740152,242969,1037780,170603,544392,684049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]