SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98340 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98340 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420117,278434,19446,270221,6709,727764,745112,351889,679812,943012,769073,498591,684810,185075,400056,217109,911891,75619,874317,460092,526673,217363,830188,425035,157820,861654,357769,480418,141402,728727,961768,115578,377569,311626,766050,951742,949670,923815,120098,53153,876403,48726,453681,645185,469873,56724,408303,163413,578109,7304,369523,349740,662425,677132,816069,558206,142689,200528,875252,714381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]